﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ZLDC.Common.Estate;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace ZLDC.Topo.BLL.Estate
{
    public class lp_YesterDays
    {
                                public static void Getjcts(System.Web.UI.HtmlControls.HtmlGenericControl a1, string deptid)
        {
            string sqlwhere = " select CONVERT(varchar,workDay,23) as workDay from lp_Configuration_main where deptid=" + deptid + " and isConfirm=0 and   DATEDIFF(dd, workDay, GETDATE()) != 0 and  workDay<CONVERT(varchar,GETDATE(),23) group by CONVERT(varchar,workDay,23)";
            DataSet ds = ZLDC.Topo.BLL.Estate.lp_Basis.Getds(sqlwhere);
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if (i == 5)
                    { 
                        a1.InnerHtml += "<br>"; 
                    }
                    a1.InnerHtml += "<a id='alit'  onclick=\"divcose('" + ds.Tables[0].Rows[i]["workDay"].ToString() + "')\">" + ds.Tables[0].Rows[i]["workDay"].ToString() + "</a>&nbsp;&nbsp;";
                }
            }
        }
    }
}
